At 11:18 AM -0400 9/13/04, Daniel Daoust wrote:
>Hi, knowing that "autonomous transaction" (Oracle
>concept of) are not yet implemented in PostgreSQL, has
>anyone found a work-around. I need to preserve
>database states from a potential rollback and then log
>them inside database tables.
What I use for this is multiple DB connections. A rollback on one
connection doesn't (generally) affect any of the other connections,
so you can keep things separate and safe from rollbacks.
Note that you can deadlock yourself this way.
--
Dan
--------------------------------------it's like this-------------------
Dan Sugalski even samurai
dan@sidhe.org have teddy bears and even
teddy bears get drunk